--alter table x_supplier(migrated)
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cCode] [varchar](10) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cName] [varchar](100) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cSupplierType] [varchar](25) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cAddress] [varchar](200) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cCity] [varchar](25) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cCountry] [varchar](25) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cZip] [varchar] (25) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cTin] [varchar](30) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cTel] [varchar](25) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cFax] [varchar](25) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cInternet] [varchar](50) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cEmail] [varchar](50) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cTerm] [varchar](25) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [nLimit] [numeric] (18,2) NULL
ALTER TABLE [dbo].[x_supplier] ALTER COLUMN [cContact] [varchar](50) NULL
--alter table client_supplier
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cName] [varchar](100) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cSupplierType] [varchar](25) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cType] [varchar](25) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cAddress] [varchar](200) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cCity] [varchar](25) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cCountry] [varchar](25) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cZip] [varchar] (25) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cTin] [varchar](30) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cTel] [varchar](25) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cFax] [varchar](25) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cInternet] [varchar](50) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cEmail] [varchar](50) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cTerm] [varchar](25) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [nLimit] [numeric] (18,2) NULL
ALTER TABLE [dbo].[client_supplier] ALTER COLUMN [cContact] [varchar](50) NULL
--alter table groupings
ALTER TABLE groupings ALTER COLUMN cID VARCHAR(50) NULL
--alter talble item
ALTER TABLE item ALTER COLUMN cGroup1 VARCHAR(50) NULL
ALTER TABLE item ALTER COLUMN cGroup2 VARCHAR(50) NULL
ALTER TABLE item ALTER COLUMN cGroup4 VARCHAR(50) NULL
ALTER TABLE item ALTER COLUMN cGroup5 VARCHAR(50) NULL
--insert terms
DECLARE @cCompanyID VARCHAR (15)
	SET @cCompanyID = '100-00'

INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '50%D/50%UDelivery', NULL, 'Terms/50% Down, 50% Upon Delivery', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '30%D/BI', NULL, 'Terms/30% Down, Balance Installment', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '90 Days-5%', NULL, 'Terms/90 Days Less 5%', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '50%D/50%UC', NULL, 'Terms/50% Down, 50% Upon Completion', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', 'Prepaid-25%-5%', NULL, 'Terms/Prepaid Less 25% Less 5%', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '50%C/50% 15Days PDC', NULL, 'Terms/50% Cash, 50% 15 Days PDC', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '50%D/BbDelivery', NULL, 'Terms/50%Down, Balance before Delivery', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', 'COD-5%', NULL, 'Terms/COD Less 5%', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '50%DbP/B7DaysADelivery', NULL, 'Terms/50%DownB4Prod, Bal7DaysAftrDelivery', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', 'Consignment', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', 'Cash', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', 'PBB', NULL, 'Terms/Monthly', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '15th/30th', NULL, 'Terms/Every 15th & 30th', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '5th/20th', NULL, 'Terms/Every 5th & 20th', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', 'Dated Check', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '120 days', NULL, 'Terms', '120', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '21 days', NULL, 'Terms', '21', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '5 days', NULL, 'Terms', '5', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '7 days PDC', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '15 days PDC', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '30 days PDC', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '45 days PDC', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '60 days PDC', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', '90 days PDC', NULL, 'Terms', '0', NULL, 1)
INSERT INTO PARAMETER_USER (cCompanyID, cType, cParamName, cModule, cDesc, cValue, nOrder, lNoEditDelete)
	VALUES (@cCompanyID, 'TERMS', 'COD Dated Check', NULL, 'Terms', '0', NULL, 1)